package org.jeecg.modules.equipment.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.equipment.controller.EquipmentQuery;
import org.jeecg.modules.equipment.entity.Equipment;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.springframework.stereotype.Repository;


/**
 * @Description: 设备
 * @Author: jeecg-boot
 * @Date:   2019-10-03
 * @Version: V1.0
 */
@Repository
public interface EquipmentMapper extends BaseMapper<Equipment> {

    public List<Equipment> page(IPage<Equipment> page, @Param("equipmentQuery") EquipmentQuery equipmentQuery);


    @Select("SELECT * FROM equipment WHERE CODE = #{code} and status=1")
    public List<Equipment> findByCode(String code);
}
